Toufong Vang
Toufong Vang
Reactions
-
Re: COUNTIFS Not Blank
<> is the expression for "not equal to", so <>"" is read as "not equal to BLANK". If it does not matter what is in the cell, that is to say "any value&q…1 · -
Re: how to get commas between join/collect of multiple sheets
The issue is caused by your use of "," to separate your JOIN(COLLECT()) expressions. E.g., JOIN(1) + "," + JOIN(2) + "," JOIN(3) + "," +…+ JOIN(8). To avoid th…1 · -
Re: Report on Last Comment date?
Hi, @Deonizia Egan , today workflow automation can be triggered by changes to attachments and comments. In this case, create a workflow automation to record a date when a comment for the row is added…1 · -
Re: Multi-Step Workflow: Creating and Linking Forms with Unique Identifiers
@Halli9 Yes, it is possible with the usage of Smartsheet's URL query string. Let's say that the URL to the Sheet 2 form that you want users to complete is: https://app.smartsheet.com/b/form/6145a2c33…1 · -
Re: Previous, Current, and Next Weeks with New Year
You are correct, @Cesar Perez , the expression is counting the days instead of the actual week number of the year. To do that, we'll need to use the WEEKNUMBER() function. The expression for the appr…1 ·
